<?php
class News_model extends CI_model {
	public function __construct(){
		$this->load->database();
	}
	
	public function get_news($slug = false){
		if($slug == false){
			$query = $this->db->get('news');
			return $query->result_array();
		}else{
			$query = $this->db->get_where('news', array('slug'=>$slug));
			return $query->row_array();
		}
		
	}
	public function set_news()
	{
		$this->load->helper('url');

		$slug = url_title($this->input->post('title'), 'dash', TRUE);

		$data = array(
		'title' => $this->input->post('title'),
		'slug' => $slug,
		'text' => $this->input->post('text')
		);

		return $this->db->insert('news', $data);
	}

	public function page_news($page=0, $per_page=20){
		$result = $this->db->query("SELECT * FROM `news` LIMIT $page, $per_page");
		return $result->result_array();
	}
}